/**
 * 
 */
package com.orange.handler.expert;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.orange.dbhelp.page.Page;
import com.orange.modules.entity.expert.AuthExam;

/**
 * @author gaogs
 *
 * 2016-11-30
 */
public interface AuthExamService {
	
	/**
	 * 保存试题
	 * @param a
	 */
	public void saveAuthExamInfo(AuthExam a);
	
	/**
	 * 删除试题
	 * @param pid
	 */
	public void deleteAuthExamInfo(String pid);
	
	/**
	 * 根据id 查询试题信息
	 * @param pid
	 * @return
	 */
	public AuthExam queryAuthExamInfo(String pid);
	
	/**
	 * 根据名称查询试题信息
	 * @param name
	 * @return
	 * @throws SQLException
	 */
	public AuthExam queryAuthExamInfoByName(String name) throws SQLException;
	
	/**
	 * 分页查询试题
	 * @param map
	 * @return
	 * @throws SQLException
	 */
	public Page<AuthExam> queryAuthExamPage(Map<String, String> map) throws SQLException;
	
	/**
	 * 根据专业技能及科目查询所有试题
	 * @param taskId
	 * @param subjectId
	 * @return
	 * @throws SQLException 
	 */
	public List<AuthExam> queryAuthExamListByTask(String taskId,String major,String subject) throws SQLException;

}
